package com.travel.service;

import java.sql.SQLException;
import java.util.List;

import com.travel.entity.Room;
import com.travel.util.PageInfo;

public interface RoomService {
	/**
	 * 增
	 */
	boolean getInsertRoom(Room room);

	/**
	 * 改
	 */
	boolean getUpdateRoom(int roomId, Room room);

	
	/**
	 * 据当前页码、每页显示个数、酒店名查询酒店记录查询客房
	 * @param pageNum
	 * @param pageSize
	 * @param hotelName
	 * @return
	 */
	PageInfo<Room> queryRoomByPageAndName(int pageNum, int pageSize, String hotelName) throws SQLException;

	/**
	 * 根据roomId删除tab_room记录的方法
	 * @param roomId
	 * @return
	 */
	boolean deleteRoomByIdSuccessOrNot(int roomId);
	
	/**
	 * 根据id查询room
	 * @return
	 */
	List<Room> getRoomById(int roomId) throws SQLException;
	
	/**
	 * 不带图片根据客房id修改客房
	 * @return
	 */
	boolean modifyRoomWithNoPictureSuccessOrNot(Room room);
	
	/**
	 * 带图片根据客房id修改客房
	 * @param room
	 * @return
	 */
	boolean modifyRoomWithPictureSuccessOrNot(Room room);
	
	
	/**
	 * 根据hotelId查询指定的hotel下的所有的room
	 * @param hotelId
	 * @return
	 */
	List<Room> queryRoomsByHotelId(int hotelId);
//	/**
//	 * 查
//	 */
//	List<Room> queryAllRooms();
}
